Tabela ToothAlignment

Definicja tabeli ToothAlignment

Name

ToothAlignment

Code

ToothAlignment

Comment

tabela okresla polozenie


Lista kolumn tabeli ToothAlignment

Name

Code

ToothAlignmentId

ToothAlignmentId

PersonId

PersonId

StartEventId

StartEventId

StopEventId

StopEventId

ToothNo

ToothNo

Rotation

Rotation

RotationDegree

RotationDegree

InclinationAlong

InclinationAlong

InclinationAcross

InclinationAcross

DisplacementArc

DisplacementArc

DisplacementAxis

DisplacementAxis

DisplacementPlane

DisplacementPlane

Active

Active

IsDeleted

IsDeleted


Kolumna ToothAlignmentId tabeli ToothAlignment

Definicja kolumny ToothAlignmentId tabeli ToothAlignment

Name

ToothAlignmentId

Code

ToothAlignmentId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonId tabeli ToothAlignment

Definicja kolumny PersonId tabeli ToothAlignment

Name

PersonId

Code

PersonId

Data Type

NUMBER(10)

Mandatory

No

Comment

id pacjenta


Kolumna StartEventId tabeli ToothAlignment

Definicja kolumny StartEventId tabeli ToothAlignment

Name

StartEventId

Code

StartEventId

Data Type

NUMBER(10)

Mandatory

No

Comment

id eventu od którego wystepuje stan


Kolumna StopEventId tabeli ToothAlignment

Definicja kolumny StopEventId tabeli ToothAlignment

Name

StopEventId

Code

StopEventId

Data Type

NUMBER(10)

Mandatory

No

Comment

id eventu do którego wystepuje


Kolumna ToothNo tabeli ToothAlignment

Definicja kolumny ToothNo tabeli ToothAlignment

Name

ToothNo

Code

ToothNo

Data Type

VARCHAR2(3)

Mandatory

No

Comment

numer zeba


Kolumna Rotation tabeli ToothAlignment

Definicja kolumny Rotation tabeli ToothAlignment

Name

Rotation

Code

Rotation

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Kod obrotu


Kolumna RotationDegree tabeli ToothAlignment

Definicja kolumny RotationDegree tabeli ToothAlignment

Name

RotationDegree

Code

RotationDegree

Data Type

NUMBER(10)

Mandatory

No

Comment

kat obrotu


Kolumna InclinationAlong tabeli ToothAlignment

Definicja kolumny InclinationAlong tabeli ToothAlignment

Name

InclinationAlong

Code

InclinationAlong

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Nachylenie osi dlugiej wzdluz wyrostka zebowego


Kolumna InclinationAcross tabeli ToothAlignment

Definicja kolumny InclinationAcross tabeli ToothAlignment

Name

InclinationAcross

Code

InclinationAcross

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Nachylenie zebow w poprzek wyrostka zebowego


Kolumna DisplacementArc tabeli ToothAlignment

Definicja kolumny DisplacementArc tabeli ToothAlignment

Name

DisplacementArc

Code

DisplacementArc

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Zmiany polozenia polegajace na przemieszczeniu równoleglym w odniesieniu do luku zebowego


Kolumna DisplacementAxis tabeli ToothAlignment

Definicja kolumny DisplacementAxis tabeli ToothAlignment

Name

DisplacementAxis

Code

DisplacementAxis

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Zmiany polozenia polegajace na przemieszczeniu równoleglym w przód, w tyl


Kolumna DisplacementPlane tabeli ToothAlignment

Definicja kolumny DisplacementPlane tabeli ToothAlignment

Name

DisplacementPlane

Code

DisplacementPlane

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Zmiany polozenia polegajace na przemieszczeniu równoleglym w odniesieniu do plaszczyzny


Kolumna Active tabeli ToothAlignment

Definicja kolumny Active tabeli ToothAlignment

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

flaga czy wpis jest aktywny


Kolumna IsDeleted tabeli ToothAlignment

Definicja kolumny IsDeleted tabeli ToothAlignment

Name

IsDeleted

Code

IsDeleted

Data Type

NUMBER(5)

Mandatory

Yes

Comment

flaga czy wpis zostal usuniety


Lista kluczy tabeli ToothAlignment

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ToothAlignment

Definicja klucza Identifier_1 tabeli ToothAlignment

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment